{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoerblad","Uitslagformulier"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Invoerblad","index":0,"n_rows":100,"n_cols":46,"rows_kept":100,"cut":false,"hidden":false,"merged":[[45,10,45,12],[26,1,27,1],[23,1,24,1],[42,1,43,1],[39,1,40,1],[36,1,37,1],[33,1,34,1],[29,1,30,1],[39,8,40,8],[36,8,37,8],[33,8,34,8],[26,8,27,8],[23,8,24,8],[40,9,40,10],[37,9,37,10],[36,9,36,10],[34,9,34,10],[33,9,33,10],[39,9,39,10],[0,20,0,22],[10,20,10,22],[19,20,19,22],[1,6,1,9],[2,6,2,9],[3,6,3,9],[4,6,4,9],[19,9,19,10],[8,8,8,9],[9,8,9,9],[10,8,10,9],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5],[6,6,6,11],[18,37,18,39],[35,37,35,39],[8,2,9,2],[8,1,9,1],[6,1,6,5],[20,9,20,10],[8,3,9,4],[20,8,21,8],[28,20,28,22],[21,9,21,10],[23,9,23,10],[32,9,32,10],[24,9,24,10],[26,9,26,10],[27,9,27,10],[20,1,21,1]]}
[null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aantal partijen gespeeld",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,"Voorronde PK:",null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(E21>0,1,FALSE)","v":1},{"$f":"IF(M24>0,1,FALSE)","v":1},{"$f":"IF(E37>0,1,FALSE)","v":1},{"$f":"IF(E37>0,1,FALSE)","v":1},{"$f":"SUM(T2:W2)","v":4},{"$f":"PRODUCT(F11,X2)","v":4}]
[null,null,null,null,"Data:",null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(M21>0,1,FALSE)","v":1},{"$f":"IF(E27>0,1,FALSE)","v":1},{"$f":"IF(M34>0,1,FALSE)","v":1},{"$f":"IF(M40>0,1,FALSE)","v":1},4,{"$f":"PRODUCT(F12,X3)","v":4}]
[null,null,null,null,"Locatie:",null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(E24>0,1,FALSE)","v":1},{"$f":"IF(M27>0,1,FALSE)","v":1},{"$f":"IF(M37>0,1,FALSE)","v":1},{"$f":"IF(E44>0,1,FALSE)","v":1},4,4]
[null,null,null,null,"Wedstrijdleider:",null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(M25>0,1,FALSE)","v":1},{"$f":"IF(E30>0,1,FALSE)","v":1},{"$f":"IF(M35>0,1,FALSE)","v":1},{"$f":"IF(E40>0,1,FALSE)","v":1},4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(M22>0,1,FALSE)","v":1},{"$f":"IF(M28>0,1,FALSE)","v":1},{"$f":"IF(E34>0,1,FALSE)","v":1},{"$f":"IF(E38>0,1,FALSE)","v":1},4,4]
[null,"NAMEN INVULLEN VOLGORDE UITNODIGING",null,null,null,null,"UITSLUITEND DE GELE VLAKKEN INVULLEN !",null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(E22>0,1,FALSE)","v":1},{"$f":"IF(E28>0,1,FALSE)","v":1},{"$f":"IF(M38>0,1,FALSE)","v":1},{"$f":"IF(E41>0,1,FALSE)","v":1},4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(E25>0,1,FALSE)","v":1},{"$f":"IF(E31>0,1,FALSE)","v":1},{"$f":"IF(E35>0,1,FALSE)","v":1},{"$f":"IF(M41>0,1,FALSE)","v":1},{"$f":"SUM(T8:W8)","v":4},4]
[null,"Bondsnr","Naam","Vereniging",null,"te maken","aanvangs","Officieel","Carambole systeem:",null,"Interval","Car."]
[null,null,null,null,null,"car.","moy.","Moyenne","Max. beurten:",null,60,"Brt."]
[1,null," ",null,null,null,null,null,"Te spelen partijen:",null,4,"Parijen",null,null,null,null,null,null,null,null,"partij moyenne"]
[2,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(H21>0,G21,0)","v":0},{"$f":"IF(H27>0,G27,0)","v":0},{"$f":"IF(H34>0,G34,0)","v":0},{"$f":"IF(P40>0,O40,0)","v":0},{"$f":"G48/G11","v":{"$error":"#DIV/0!"}}]
[3,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(P21>0,O21,0)","v":0},{"$f":"IF(P27>0,O27,0)","v":0},{"$f":"IF(P34>0,O34,0)","v":0},{"$f":"IF(P40>0,O40,0)","v":0},{"$f":"G49/G12","v":{"$error":"#DIV/0!"}}]
[4,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(H24>0,G24,0)","v":0},{"$f":"IF(H30>0,G30,0)","v":0},{"$f":"IF(P35>0,O35,0)","v":0},{"$f":"IF(P41>0,O41,0)","v":0},{"$f":"G50/G13","v":{"$error":"#DIV/0!"}}]
[5,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(P24>0,O24,0)","v":0},{"$f":"IF(H31>0,G31,0)","v":0},{"$f":"IF(H37>0,G37,0)","v":0},{"$f":"IF(H43>0,G43,0)","v":0},{"$error":"#DIV/0!"}]
[6,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(P22>0,O22,0)","v":0},{"$f":"IF(P25>0,O25,0)","v":0},{"$f":"IF(H35>0,G35,0)","v":0},{"$f":"IF(P38>0,O38,0)","v":0},{"$error":"#DIV/0!"}]
[7,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(H25>0,G25,0)","v":0},{"$f":"IF(H28>0,G28,0)","v":0},{"$f":"IF(H40>0,G40,0)","v":0},{"$f":"IF(H44>0,G44,0)","v":0},{"$f":"G53/G16","v":{"$error":"#DIV/0!"}}]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(H22>0,G22,0)","v":0},{"$f":"IF(P28>0,O28,0)","v":0},{"$f":"IF(H38>0,G38,0)","v":0},{"$f":"IF(H41>0,G41,0)","v":0},{"$error":"#DIV/0!"}]
[null,"Partijen:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partij","Car %",null,null,"Interval pnt. bij max. brt.",null,"Speelrooster"]
[null,null,"Naam","Car.","Brt.","HS","Moy.","Pnt.",null,"Naam",null,"Car.","Brt.","HS","Moy.","Pnt.",null,null,null,null,"partijen gewonnen"]
[null,null,{"$f":"C11","v":" "},null," "," ",{"$f":"ROUNDDOWN(D21/E21,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E21=K10,D21<F11,D22<F17),AJ21,      IF(AND(D21=F11,D22<F17),2,IF(AND(D21=F11,D22=F17),1,0)))","v":0},null,{"$f":"C12","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L21/M21,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M21=K10,L21<F12,L22<F15),AJ22,      IF(AND(L21=F12,L22<F15),2,IF(AND(L21=F12,L22=F15),1,0)))","v":0},null,null,1,{"$f":"IF(H21>1,1,0)","v":0},{"$f":"IF(H27>1,1,0)","v":0},{"$f":"IF(H34>1,1,0)","v":0},{"$f":"IF(P40>1,1,0)","v":0},{"$f":"SUM(T21:W21)","v":0},null,{"$f":"IF(D21=F11,1,0)","v":1},{"$f":"IF(D22<F17,1,0)","v":0},{"$f":"SUM(Z21:AA21)","v":1},{"$f":"IF(L21=F12,1,0)","v":0},{"$f":"IF(L22<F15,1,0)","v":0},{"$f":"SUM(AC21:AD21)","v":0},1,{"$f":"ROUNDDOWN(D21/F11,3)","v":{"$error":"#DIV/0!"}},"-",{"$f":"ROUNDDOWN(D22/F17,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG21<AI21,0,IF(AG21>AI21,2,1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(AI21<AG21,0,IF(AI21>AG21,2,1))","v":{"$error":"#VALUE!"}},1,"-",7]
[null,null,{"$f":"C17","v":" "}," ",{"$f":"E21","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E22=K10,D22<F17,D21<F11),AK21,      IF(AND(D22=F17,D21<F11),2,IF(AND(D22=F17,D21=F11),1,0)))","v":0},null,{"$f":"C15","v":" "},null," ",{"$f":"M21","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M22=K10,L22<F15,L21<F12),AK22,      IF(AND(L22=F15,L21<F12),2,IF(AND(L22=F15,L21=F12),1,0)))","v":0},null,null,2,{"$f":"IF(P21>1,1,0)","v":0},{"$f":"IF(P27>1,1,0)","v":0},{"$f":"IF(P34>1,1,0)","v":0},{"$f":"IF(P41>1,1,0)","v":0},0,null,{"$f":"IF(D22=F17,1,0)","v":0},{"$f":"IF(D21<F11,1,0)","v":0},{"$f":"SUM(Z22:AA22)","v":0},{"$f":"IF(L22=F15,1,0)","v":0},{"$f":"IF(L21<F12,1,0)","v":0},{"$f":"SUM(AC22:AD22)","v":0},2,{"$f":"ROUNDDOWN(L21/F12,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L22/F15,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG22<AI22,0,IF(AG22>AI22,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI22<AG22,0,IF(AI22>AG22,2,1))","v":{"$error":"#VALUE!"}},2,"-",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(H24>1,1,0)","v":0},{"$f":"IF(H30>1,1,0)","v":0},{"$f":"IF(P35>1,1,0)","v":0},{"$f":"IF(P37>1,1,0)","v":0},0,null,null,null,null,null,null,null,3,{"$f":"ROUNDDOWN(D24/F13,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D25/F16,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},3,"-",6]
[null,null,{"$f":"C13","v":" "}," "," "," ",{"$f":"ROUNDDOWN(D24/E24,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E24=K10,D24<F13,D25<F16),AJ23,      IF(AND(D24=F13,D25<F16),2,IF(AND(D24=F13,D25=F16),1,0)))","v":0},null,{"$f":"C14","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L24/M24,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M24=K10,L24<F14,L25<F15),AJ24,      IF(AND(L24=F14,L25<F15),2,IF(AND(L24=F14,L25=F15),1,0)))","v":0},null,null,4,{"$f":"IF(P24>1,1,0)","v":0},{"$f":"IF(H31>1,1,0)","v":0},{"$f":"IF(H37>1,1,0)","v":0},{"$f":"IF(H43>1,1,0)","v":0},0,null,{"$f":"IF(D24=F13,1,0)","v":0},{"$f":"IF(D25<F16,1,0)","v":0},0,{"$f":"IF(L24=F14,1,0)","v":0},{"$f":"IF(L25<F15,1,0)","v":0},0,4,{"$f":"ROUNDDOWN(L24/F14,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L25/F15,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},4,"-",5]
[null,null,{"$f":"C16","v":" "}," ",{"$f":"E24","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E25=K10,D25<F16,D24<F13),AK23,      IF(AND(D25=F16,D24<F13),2,IF(AND(D25=F13,D24=F16),1,0)))","v":0},null,{"$f":"C15","v":" "},null," ",{"$f":"M24","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M25=K10,L25<F15,L24<F14),AK24,      IF(AND(L25=F15,L24<F14),2,IF(AND(L25=F15,L24=F14),1,0)))","v":0},null,null,5,{"$f":"IF(P22>1,1,0)","v":0},{"$f":"IF(P25>1,1,0)","v":0},{"$f":"IF(H35>1,1,0)","v":0},{"$f":"IF(P38>1,1,0)","v":0},0,null,{"$f":"IF(D25=F16,1,0)","v":0},{"$f":"IF(D24<F13,1,0)","v":0},0,{"$f":"IF(L25=F15,1,0)","v":0},{"$f":"IF(L24<F14,1,0)","v":0},0,5,{"$f":"ROUNDDOWN(D27/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D28/F16,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,"-",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(H25>1,1,0)","v":0},{"$f":"IF(H28>1,1,0)","v":0},{"$f":"IF(H40>1,1,0)","v":0},{"$f":"IF(H44>1,1,0)","v":0},0,null,null,null,null,null,null,null,6,{"$f":"ROUNDDOWN(L27/F12,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L28/F17,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},2,"-",7]
[null,null,{"$f":"C11","v":" "}," "," "," ",{"$f":"ROUNDDOWN(D27/E27,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E27=K10,D27<F11,D28<F16),AJ25,      IF(AND(D27=F11,D28<F16),2,IF(AND(D27=F11,D28=F16),1,0)))","v":0},null,{"$f":"C12","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L27/M27,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M27=K10,L27<F12,L28<F17),AJ26,      IF(AND(L27=F12,L28<F17),2,IF(AND(L27=F12,L28=F17),1,0)))","v":0},null,null,7,{"$f":"IF(H22>1,1,0)","v":0},{"$f":"IF(P28>1,1,0)","v":0},{"$f":"IF(H38>1,1,0)","v":0},{"$f":"IF(P41>1,1,0)","v":0},0,null,{"$f":"IF(D27=F11,1,0)","v":0},{"$f":"IF(D28<F16,1,0)","v":0},0,{"$f":"IF(L27=F12,1,0)","v":0},{"$f":"IF(L28<F17,1,0)","v":0},0,7,{"$f":"ROUNDDOWN(D30/F13,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D31/F14,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},3,"-",4]
[null,null,{"$f":"C16","v":" "}," ",{"$f":"E27","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E28=K10,D28<F16,D27<F11),AK25,      IF(AND(D28=F16,D27<F11),2,IF(AND(D28=F16,D27=F11),1,0)))","v":0},null,{"$f":"C17","v":" "},null," ",{"$f":"M27","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M28=K10,L28<F17,L27<F12),AK26,      IF(AND(L28=F17,L27<F12),2,IF(AND(L28=F17,L27=F12),1,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D28=F16,1,0)","v":0},{"$f":"IF(D27<F11,1,0)","v":0},0,{"$f":"IF(L28=F17,1,0)","v":0},{"$f":"IF(L27<F12,1,0)","v":0},0,8,{"$f":"ROUNDDOWN(D34/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D35/F15,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG28<AI28,0,IF(AG28>AI28,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI28<AG28,0,IF(AI28>AG28,2,1))","v":{"$error":"#VALUE!"}},1,"-",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"partijen gelijk",null,null,null,null,null,null,null,null,null,null,9,{"$f":"ROUNDDOWN(L34/F12,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L35/F13,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG29<AI29,0,IF(AG29>AI29,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI29<AG29,0,IF(AI29>AG29,2,1))","v":{"$error":"#VALUE!"}},2,"-",3]
[null,null,{"$f":"C13","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D30/E30,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E30=K10,D30<F13,D31<F14),AJ27,      IF(AND(D30=F13,D31<F14),2,IF(AND(D30=F13,D31=F14),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D30=F13,1,0)","v":0},{"$f":"IF(D31<F14,1,0)","v":0},0,null,null,null,10,{"$f":"ROUNDDOWN(D37/F14,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D38/F17,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},4,"-",7]
[null,null,{"$f":"C14","v":" "}," ",{"$f":"E30","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(E31=K10,D31<F14,D30<F13),AK27,      IF(AND(D31=F14,D30<F13),2,IF(AND(D31=F14,D30=F13),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(H21=1,1,0)","v":0},{"$f":"IF(H27=1,1,0)","v":0},{"$f":"IF(H34=1,1,0)","v":0},{"$f":"IF(P40=1,1,0)","v":0},{"$f":"SUM(T31:W31)","v":0},null,{"$f":"IF(D31=F14,1,0)","v":0},{"$f":"IF(D30<F13,1,0)","v":0},0,null,null,null,11,{"$f":"ROUNDDOWN(L37/F13,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L38/F17,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG31<AI31,0,IF(AG31>AI31,2,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(AI31<AG31,0,IF(AI31>AG31,2,1))","v":{"$error":"#VALUE!"}},3,"-",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(P21=1,1,0)","v":0},{"$f":"IF(P27=1,1,0)","v":0},{"$f":"IF(P34=1,1,0)","v":0},{"$f":"IF(P41=1,1,0)","v":0},0,null,null,null,null,null,null,null,12,{"$f":"ROUNDDOWN(D40/F16,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D41/F17,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},6,"-",7]
[null,null,"Naam","Car.","Brt.","HS","Moy.","Pnt.",null,"Naam",null,"Car.","Brt.","HS","Moy.","Pnt.",null,null,3,{"$f":"IF(H24=1,1,0)","v":0},{"$f":"IF(H30=1,1,0)","v":0},{"$f":"IF(P35=1,1,0)","v":0},{"$f":"IF(P37=1,1,0)","v":0},0,null,null,null,null,null,null,null,13,{"$f":"ROUNDDOWN(L40/F11,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(L41/F15,3)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},1,"-",2]
[null,null,{"$f":"C11","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D34/E34,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E34=K10,D34<F11,D35<F15),AJ28,      IF(AND(D34=F11,D35<F15),2,IF(AND(D34=F11,D35=F15),1,0)))","v":0},null,{"$f":"C12","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L34/M34,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M34=K10,L34<F12,L35<F13),AJ29,      IF(AND(L34=F12,L35<F13),2,IF(AND(L34=F12,L35=F13),1,0)))","v":0},null,null,4,{"$f":"IF(P24=1,1,0)","v":0},{"$f":"IF(H31=1,1,0)","v":0},{"$f":"IF(H37=1,1,0)","v":0},{"$f":"IF(H43=1,1,0)","v":0},0,null,{"$f":"IF(D34=F11,1,0)","v":0},{"$f":"IF(D35<F15,1,0)","v":0},0,{"$f":"IF(L34=F12,1,0)","v":0},{"$f":"IF(L35<F13,1,0)","v":0},0,14,{"$f":"ROUNDDOWN(D43/F14,3)","v":{"$error":"#VALUE!"}},"-",{"$f":"ROUNDDOWN(D44/F16,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG34<AI34,0,IF(AG34>AI34,2,1))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},4,"-",6]
[null,null,{"$f":"C15","v":" "}," ",{"$f":"E34","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(E35=K10,D35<F15,D34<F11),AK28,      IF(AND(D35=F15,D34<F11),2,IF(AND(D35=F15,D34=F11),1,0)))","v":0},null,{"$f":"C13","v":" "},null," ",{"$f":"M34","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M35=K10,L35<F13,L34<F12),AK29,      IF(AND(L35=F13,L34<F12),2,IF(AND(L35=F13,L34=F12),1,0)))","v":0},null,null,5,{"$f":"IF(P22=1,1,0)","v":0},{"$f":"IF(P25=1,1,0)","v":0},{"$f":"IF(H35=1,1,0)","v":0},{"$f":"IF(P38=1,1,0)","v":0},0,null,{"$f":"IF(D35=F15,1,0)","v":0},{"$f":"IF(D34<F11,1,0)","v":0},0,{"$f":"IF(L35=F13,1,0)","v":0},{"$f":"IF(L34<F12,1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(H25=1,1,0)","v":0},{"$f":"IF(H28=1,1,0)","v":0},{"$f":"IF(H40=1,1,0)","v":0},{"$f":"IF(H44=1,1,0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spelen niet tegen elkaar"]
[null,null,{"$f":"C14","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D37/E37,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E37=K10,D37<F14,D38<F17),AJ30,      IF(AND(D37=F14,D38<F17),2,IF(AND(D37=F14,D38=F17),1,0)))","v":0},null,{"$f":"C13","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L37/M37,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M37=K10,L37<F13,L38<F15),AJ31,      IF(AND(L37=F13,L38<F15),2,IF(AND(L37=F13,L38=F15),1,0)))","v":0},null,null,7,{"$f":"IF(H22=1,1,0)","v":0},{"$f":"IF(P28=1,1,0)","v":0},{"$f":"IF(H38=1,1,0)","v":0},{"$f":"IF(H41=1,1,0)","v":0},0,null,{"$f":"IF(D37=F14,1,0)","v":0},{"$f":"IF(D38<F17,1,0)","v":0},0,{"$f":"IF(L37=F13,1,0)","v":0},{"$f":"IF(L38<F15,1,0)","v":0},0,null,null,null,null,null,null,1,3,4]
[null,null,{"$f":"C17","v":" "}," ",{"$f":"E37","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(E38=K10,D38<F17,D37<F14),AK30,      IF(AND(D38=F17,D37<F14),2,IF(AND(D38=F17,D37=F14),1,0)))","v":0},null,{"$f":"C15","v":" "},null," ",{"$f":"M37","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M38=K10,L38<F15,L37<F13),AK31,      IF(AND(L38=F15,L37<F13),2,IF(AND(L38=F15,L37=F13),1,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D38=F17,1,0)","v":0},{"$f":"IF(D37<F14,1,0)","v":0},0,{"$f":"IF(L38=F15,1,0)","v":0},{"$f":"IF(L37<F13,1,0)","v":0},0,null,null,null,null,null,null,2,4,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,1,7]
[null,null,{"$f":"C16","v":" "}," "," ",null,{"$f":"ROUNDDOWN(D40/E40,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E40=K10,D40<F16,D41<F17),AJ32,      IF(AND(D40=F16,D41<F17),2,IF(AND(D40=F16,D41=F17),1,0)))","v":0},null,{"$f":"C11","v":" "},null," "," ",null,{"$f":"ROUNDDOWN(L40/M40,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(M40=K10,L40<F11,L41<F12),AJ33,      IF(AND(L40=F11,L41<F12),2,IF(AND(L40=F11,L41=F12),1,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D40=F16,1,0)","v":0},{"$f":"IF(D41<F17,1,0)","v":0},0,{"$f":"IF(L40=F11,1,0)","v":0},{"$f":"IF(L41<F12,1,0)","v":0},0,null,null,null,null,null,null,4,1,2]
[null,null,{"$f":"C17","v":" "}," ",{"$f":"E40","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(E41=K10,D41<F17,D40<F16),AK32,      IF(AND(D41=F17,D40<F16),2,IF(AND(D41=F17,D40=F16),1,0)))","v":0},null,{"$f":"C12","v":" "},null," ",{"$f":"M40","v":" "},null,{"$error":"#VALUE!"},{"$f":"IF(AND(M41=K10,L41<F12,L40<F11),AK33,      IF(AND(L41=F12,L40<F11),2,IF(AND(L41=F12,L40=F11),1,0)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=F17,1,0)","v":0},{"$f":"IF(D40<F16,1,0)","v":0},0,{"$f":"IF(L41=F12,1,0)","v":0},{"$f":"IF(L40<F11,1,0)","v":0},0,null,null,null,null,null,null,5,6,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,2,5]
[null,null,{"$f":"C14","v":" "}," "," "," ",{"$f":"ROUNDDOWN(D43/E43,3)","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E43=K10,D43<F14,D44<F16),AJ34,      IF(AND(D43=F14,D44<F16),2,IF(AND(D43=F14,D44=F16),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D43=F14,1,0)","v":0},{"$f":"IF(D44<F16,1,0)","v":0},0,null,null,null,null,null,null,null,null,null,7,1,6]
[null,null,{"$f":"C16","v":" "}," ",{"$f":"E43","v":" "}," ",{"$error":"#VALUE!"},{"$f":"IF(AND(E44=K10,D44<F16,D43<F14),AK34,      IF(AND(D44=F16,D43<F14),2,IF(AND(D44=F16,D43=F14),1,0)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D44=F16,1,0)","v":0},{"$f":"IF(D43<F14,1,0)","v":0},0]
[null,null,null,null,null," "]
[null,"Stand",null,null,null,null,null,null,null,null,"Plaatsing "]
[null,null,null,"Car.","Brt.","HS","Moy.","Pnt.","% moy.","% carb.","Mp.","% moy.","% carb.","Rangking"]
[null,null,{"$f":"C11","v":" "},{"$f":"SUM(D21,D27,D34,L40)","v":0},{"$f":"SUM(E21,E27,E34,M40)","v":0},{"$f":"MAX(F21,F27,F34,N40)","v":0},{"$f":"ROUNDDOWN(D48/E48,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H21,H27,H34,P40)","v":0},{"$f":"IF(OR(ISBLANK(D48),ISBLANK(E48)),\"-\",IF(AND(H11=\"NEE\",G48/G11>1),100,ROUNDDOWN(G48/G11%,2)))","v":{"$error":"#DIV/0!"}},{"$f":"D48/Y2","v":0},null,null,null,{"$f":"SUM(K48:M48)","v":0}]
[null,null," ",{"$f":"SUM(L21,L27,L34,L41)","v":0},{"$f":"SUM(M21,M27,M34,M41)","v":0},{"$f":"MAX(N21,N27,N34,N41)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(P21,P27,P34,P41)","v":0},{"$error":"#DIV/0!"},{"$f":"D49/Y3","v":0},null,null,null,{"$f":"SUM(K49:M49)","v":0}]
[null,null," ",{"$f":"SUM(D24,D30,L35,L37)","v":0},{"$f":"SUM(E24,E30,M35,M37)","v":0},{"$f":"MAX(F24,F30,N35,N37)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H24,H30,P35,P37)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[null,null," ",{"$f":"SUM(L24,D31,D37,D43)","v":0},{"$f":"SUM(M24,E31,E37,E43)","v":0},{"$f":"MAX(N24,F31,F37,F43)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(P24,H31,H37,H43)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[null,null," ",{"$f":"SUM(L22,L25,D35,L38)","v":0},{"$f":"SUM(M22,M25,E35,M38)","v":0},{"$f":"MAX(N22,N25,F35,N38)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(P22,P25,H35,P38)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[null,null," ",{"$f":"SUM(D25,D28,D40,D44)","v":0},{"$f":"SUM(E25,E28,E40,E44)","v":0},{"$f":"MAX(F25,F28,F40,F44)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H25,H28,H40,H44)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[null,null," ",{"$f":"SUM(D22,L28,D38,D41)","v":0},{"$f":"SUM(E22,M28,E38,E41)","v":0},{"$f":"MAX(F22,N28,F38,F41)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H22,P28,H38,H41)","v":0},{"$error":"#DIV/0!"},0,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"Uitslagformulier","index":1,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,12,2,14],[32,7,32,8],[33,7,33,8],[34,7,34,8],[31,7,31,8],[29,5,29,8],[24,9,24,10],[25,9,29,10],[1,1,1,4],[1,5,1,9],[13,7,13,9],[14,7,14,9],[14,3,14,6],[13,3,13,6],[23,0,23,3],[23,5,23,8],[30,0,30,3],[30,5,30,8],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[24,0,24,3],[24,5,24,8],[26,5,26,8],[27,5,27,8],[28,5,28,8]]}
[]
[null,"Uitslagformulier voorronden ",null,null,null,{"$f":"Invoerblad!G2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plaatsing "]
[null,"Bondsnr.","Naam","Gew.","Remise","Carb.","Brt.","HS.","Pnt.","Moyenne","% moy.","% carb.","Mp.","% moy.","% carb.","Rangking"]
[null,null,null," "," "]
[1,{"$f":"Invoerblad!B11","v":0},{"$f":"Invoerblad!C11","v":" "},{"$f":"Invoerblad!X21","v":0},{"$f":"Invoerblad!X31","v":0},{"$f":"Invoerblad!D48","v":0},{"$f":"Invoerblad!E48","v":0},{"$f":"Invoerblad!F48","v":0},{"$f":"Invoerblad!H48","v":0},{"$f":"Invoerblad!G48","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I48/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J48/100","v":0},{"$f":"Invoerblad!K48/100","v":0},{"$f":"Invoerblad!L48/100","v":0},{"$f":"Invoerblad!M48/100","v":0},{"$f":"Invoerblad!N48/100","v":0}]
[2,{"$f":"Invoerblad!B12","v":0},{"$f":"Invoerblad!C12","v":" "},{"$f":"Invoerblad!X22","v":0},{"$f":"Invoerblad!X32","v":0},{"$f":"Invoerblad!D49","v":0},{"$f":"Invoerblad!E49","v":0},{"$f":"Invoerblad!F49","v":0},{"$f":"Invoerblad!H49","v":0},{"$f":"Invoerblad!G49","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I49/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J49/100","v":0},{"$f":"Invoerblad!K49/100","v":0},{"$f":"Invoerblad!L49/100","v":0},{"$f":"Invoerblad!M49/100","v":0},{"$f":"Invoerblad!N49/100","v":0}]
[3,{"$f":"Invoerblad!B13","v":0},{"$f":"Invoerblad!C13","v":" "},{"$f":"Invoerblad!X23","v":0},{"$f":"Invoerblad!X33","v":0},{"$f":"Invoerblad!D50","v":0},{"$f":"Invoerblad!E50","v":0},{"$f":"Invoerblad!F50","v":0},{"$f":"Invoerblad!H50","v":0},{"$f":"Invoerblad!G50","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I50/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J50/100","v":0},{"$f":"Invoerblad!K50/100","v":0},{"$f":"Invoerblad!L50/100","v":0},{"$f":"Invoerblad!M50/100","v":0},{"$f":"Invoerblad!N50/100","v":0}]
[4,{"$f":"Invoerblad!B14","v":0},{"$f":"Invoerblad!C14","v":" "},{"$f":"Invoerblad!X24","v":0},{"$f":"Invoerblad!X34","v":0},{"$f":"Invoerblad!D51","v":0},{"$f":"Invoerblad!E51","v":0},{"$f":"Invoerblad!F51","v":0},{"$f":"Invoerblad!H51","v":0},{"$f":"Invoerblad!G51","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I51/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J51/100","v":0},{"$f":"Invoerblad!K51/100","v":0},{"$f":"Invoerblad!L51/100","v":0},{"$f":"Invoerblad!M51/100","v":0},{"$f":"Invoerblad!N51/100","v":0}]
[5,{"$f":"Invoerblad!B15","v":0},{"$f":"Invoerblad!C15","v":" "},{"$f":"Invoerblad!X25","v":0},{"$f":"Invoerblad!X35","v":0},{"$f":"Invoerblad!D52","v":0},{"$f":"Invoerblad!E52","v":0},{"$f":"Invoerblad!F52","v":0},{"$f":"Invoerblad!H52","v":0},{"$f":"Invoerblad!G52","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I52/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J52/100","v":0},{"$f":"Invoerblad!K52/100","v":0},{"$f":"Invoerblad!L52/100","v":0},{"$f":"Invoerblad!M52/100","v":0},{"$f":"Invoerblad!N52/100","v":0}]
[6,{"$f":"Invoerblad!B16","v":0},{"$f":"Invoerblad!C16","v":" "},{"$f":"Invoerblad!X26","v":0},{"$f":"Invoerblad!X36","v":0},{"$f":"Invoerblad!D53","v":0},{"$f":"Invoerblad!E53","v":0},{"$f":"Invoerblad!F53","v":0},{"$f":"Invoerblad!H53","v":0},{"$f":"Invoerblad!G53","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I53/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J53/100","v":0},{"$f":"Invoerblad!K53/100","v":0},{"$f":"Invoerblad!L53/100","v":0},{"$f":"Invoerblad!M53/100","v":0},{"$f":"Invoerblad!N53/100","v":0}]
[7,{"$f":"Invoerblad!B17","v":0},{"$f":"Invoerblad!C17","v":" "},{"$f":"Invoerblad!X27","v":0},{"$f":"Invoerblad!X37","v":0},{"$f":"Invoerblad!D54","v":0},{"$f":"Invoerblad!E54","v":0},{"$f":"Invoerblad!F54","v":0},{"$f":"Invoerblad!H54","v":0},{"$f":"Invoerblad!G54","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!I54/100","v":{"$error":"#DIV/0!"}},{"$f":"Invoerblad!J54/100","v":0},{"$f":"Invoerblad!K54/100","v":0},{"$f":"Invoerblad!L54/100","v":0},{"$f":"Invoerblad!M54/100","v":0},{"$f":"Invoerblad!N54/100","v":0}]
[]
[null,null,null,"Naam locatie",null,null,null,"Datum"]
[null,null,null,{"$f":"Invoerblad!G4","v":0},null,null,null,{"$f":"TODAY()","v":"2023-11-14"}]
[]
["DIT FORMULIER DUIDELIJK INGEVULD EN VOORZIEN VAN DE HANDTEKENING "]
[]
["VAN EEN LID VAN DE ORGANISERENDE VERENIGING           BINNEN 3 DAGEN "]
[]
["NA AFLOOP VAN DE VOORWEDSTRIJDEN TOEZENDEN OF MAILEN AAN:  "]
[]
["﻿ "]
["Met vriendelijke groet"]
["Wedstrijdleider PK  Libre en Bandstoten",null,null,null,null,null,null,null,null,"handtekening:"]
[null,null,null,null,null,null,null,null,null,{"$f":"Invoerblad!G5","v":0}]
["Johan Jansink"]
["Veemarkt 11"]
["7121 AH  Aalten"]
["Tel: 0543-472292 / 06-40263789"]
["E-mail: j.jansink2016@gmail.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"made by Marco Ubbink"]